﻿CREATE TABLE [dbo].[MobileSMSRecord] (
    [ID]          UNIQUEIDENTIFIER NOT NULL,
    [Mobile]      VARCHAR (15)     NOT NULL,
    [AddDate]     DATETIME         NOT NULL,
    [MobileVCode] VARCHAR (10)     NULL,
    [ImageVCode]  NVARCHAR (10)    NULL,
    [SMSContent]  NVARCHAR (200)   NULL,
    [IP]          VARCHAR (64)     NULL,
    [OtherDetail] NVARCHAR (MAX)   NULL,
    [TenantID]    UNIQUEIDENTIFIER NULL
);




GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'手机号短信发送统计表。手机号短信发送记录(未登录用户的记录，如注册验证)', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'MobileSMSRecord';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'手机号', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'MobileSMSRecord', @level2type = N'COLUMN', @level2name = N'Mobile';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'记录时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'MobileSMSRecord', @level2type = N'COLUMN', @level2name = N'AddDate';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'手机验证码', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'MobileSMSRecord', @level2type = N'COLUMN', @level2name = N'MobileVCode';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'图片验证码', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'MobileSMSRecord', @level2type = N'COLUMN', @level2name = N'ImageVCode';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'短信内容', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'MobileSMSRecord', @level2type = N'COLUMN', @level2name = N'SMSContent';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'终端详细记录', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'MobileSMSRecord', @level2type = N'COLUMN', @level2name = N'OtherDetail';

